import openpyxl
book = openpyxl.load_workbook("pp.xlsx")
shl = book.active
rows = shl.max_row
clos = shl.max_column
print(rows, clos)

B2 = shl.cell(2, 2).value
print(B2)

row1 = shl.iter_rows(max_row=1)
for i in row1:
    for j in i:
       print(j.value, end='\t')
